SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROC [dbo].[usp_CapNhatThanhVien]
	@MaTV CHAR(12),
	@cmnd CHAR(10),
	@quoc_tich nvarchar(20),
	@dia_chi nvarchar(100),
	@mat_khau varchar(30),
	@gioi_tinh CHAR(3),
	@ho_chieu varchar(15),
	@email varchar(50),
	@nghe_nghiep nvarchar(20),
	@dt1 VARCHAR(12),
	@dt2 VARCHAR(12)
AS
BEGIN
	UPDATE dbo.THANH_VIEN
	SET CMND = @cmnd,
		QUOC_TICH = @quoc_tich,
		DIA_CHI = @dia_chi,
		MAT_KHAU = @mat_khau,
		GIOI_TINH = @gioi_tinh,
		HO_CHIEU = @ho_chieu,
		EMAIL = @email,
		NGHE_NGHIEP = @nghe_nghiep,
		DIEN_THOAI_1 = @dt1,
		DIEN_THOAI_2 = @dt2
	WHERE MATV = @MaTV  
END

GO
